Page 73 - 2629_Devagiri_C-8

The MySQL prompt appears, allowing queries to be performed on the MySQL server.
MySQL

MySQL is an open-source RDBMS software. It uses a query language called SQL. Some of its

important features include:
MySQL is free and open-source.

Ideal for both small and large applications.
Very fast, reliable, scalable and easy to use.

Cross-platform and compliant with the ANSI SQL standard.
Developed, distributed and supported by Oracle Corporation.
Runs on all operating systems, including Linux, Unix and Windows.

You can install the MySQL Installer by downloading it from the official MySQL website:

https://dev.mysql.com/downloads PRIVACY PRACTICES
Follow the installation instructions. Update your database passwords regularly, avoid reusing them and always back up your

https://orangewebsupport.co.in/CodepilotV5.0_C8/MySQL_Server_Installation.pdf database work.

STARTING MYSQL SERVER APPLICATION
The steps to start MySQL Server application are as follows:
SQL DATA TYPES

A data type defines the type of value that a column will contain. In a database table, every
2 Click on the All option. column must have a name and a data type. Some common SQL data types and their descriptions
listed below:

Data Type Description Example

age INT;
INTEGER(INT) Stores whole numbers (no decimals).
Example: 25, 30
Stores fixed-length character strings of gender CHAR(1);
3 Click on the MySQL 8.0 CHAR(n)
Command Line Client option. size n. Example: ‘M’, ‘F’
Stores variable-length character strings name VARCHAR(50);
VARCHAR(n)
with a maximum size of n. Example: ‘Yash Gupta’, ‘Sonia’

1 Click on the Start button. Stores numbers with precision p and price DECIMAL(5,2);

DECIMAL(p,s)
scale s. Example: 123.45, 99.99
Stores date values in YYYY-MM-DD birthdate DATE;
DATE
format. Example: ‘1990-05-25’

Stores floating-point numbers with temperature FLOAT(5);
4 Enter the password and press the Enter key. FLOAT(p)
precision p. Example: 98.6, 35.75

appointment_time TIME;
TIME Stores time values in HH:MM:SS format.
Example: ‘10:30:00’, ‘15:45:00’

71
MySQL: My First Database